Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_DEQUEUE_QUEUES

`ALL_DEQUEUE_QUEUES` describes all queues accessible to the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the queue
`NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the queue
`QUEUE_TABLE` | `VARCHAR2(30)` | `NOT NULL` | Name of the table in which the queue data resides
`QID` | `NUMBER` | `NOT NULL` | Object number of the queue
`QUEUE_TYPE` | `VARCHAR2(20)` |  | Type of the queue
`MAX_RETRIES` | `NUMBER` |  | Maximum number of retries allowed when dequeuing from the queue
`RETRY_DELAY` | `NUMBER` |  | Time interval between retries
`ENQUEUE_ENABLED` | `VARCHAR2(7)` |  | Queue is enabled for enqueue
`DEQUEUE_ENABLED` | `VARCHAR2(7)` |  | Queue is enabled for dequeue
`RETENTION` | `VARCHAR2(40)` |  | Time interval that processed messages are retained in the queue
`USER_COMMENT` | `VARCHAR2(50)` |  | User-specified comment
`NETWORK_NAME` | `VARCHAR2(64)` |  | Network name